/*
 Navicat Premium Data Transfer

 Source Server         : 公司阿里云
 Source Server Type    : SQL Server
 Source Server Version : 13005026
 Source Host           : 121.40.101.29:1433
 Source Catalog        : scm_main_sfl_visit_dev
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 13005026
 File Encoding         : 65001

 Date: 18/12/2020 16:23:56
*/


-- ----------------------------
-- Table structure for bd_sys_role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bd_sys_role]') AND type IN ('U'))
	DROP TABLE [dbo].[bd_sys_role]
GO

CREATE TABLE [dbo].[bd_sys_role] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [name] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [remark] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [status] int  NOT NULL,
  [parent_id] int  NULL,
  [update_user] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime  NULL,
  [creation_user] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [creation_time] datetime DEFAULT (getdate()) NULL
)
GO

ALTER TABLE [dbo].[bd_sys_role] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键自增 角色id',
'SCHEMA', N'dbo',
'TABLE', N'bd_sys_role',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色名',
'SCHEMA', N'dbo',
'TABLE', N'bd_sys_role',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色备注',
'SCHEMA', N'dbo',
'TABLE', N'bd_sys_role',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色状态',
'SCHEMA', N'dbo',
'TABLE', N'bd_sys_role',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父级ID',
'SCHEMA', N'dbo',
'TABLE', N'bd_sys_role',
'COLUMN', N'parent_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'bd_sys_role',
'COLUMN', N'update_user'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间',
'SCHEMA', N'dbo',
'TABLE', N'bd_sys_role',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'bd_sys_role',
'COLUMN', N'creation_user'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'bd_sys_role',
'COLUMN', N'creation_time'
GO


-- ----------------------------
-- Records of [bd_sys_role]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[bd_sys_role] ON
GO

INSERT INTO [dbo].[bd_sys_role] ([id], [name], [remark], [status], [parent_id], [update_user], [update_time], [creation_user], [creation_time]) VALUES (N'1', N'超级管理员', N'超级管理员', N'0', NULL, NULL, NULL, NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[bd_sys_role] OFF
GO

